/*
Navicat MySQL Data Transfer

Source Server         : localhost
Source Server Version : 50027
Source Host           : localhost:3306
Source Database       : trabalhojava

Target Server Type    : MYSQL
Target Server Version : 50027
File Encoding         : 65001

Date: 2013-12-04 00:31:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `cliente`
-- ----------------------------
DROP TABLE IF EXISTS `cliente`;
CREATE TABLE `cliente` (
`nome`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`sobrenome`  varchar(50) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`rg`  varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`cpf`  varchar(11) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`endereco`  varchar(200) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ,
`salario`  double NOT NULL ,
`codCliente`  int(10) NOT NULL AUTO_INCREMENT ,
PRIMARY KEY (`codCliente`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=5

;

-- ----------------------------
-- Records of cliente
-- ----------------------------
BEGIN;
INSERT INTO `cliente` VALUES ('RAFAEL', 'KOZAR', '0980', '890', 'ponta', '1990', '1'), ('Paula', 'Silva', '9090909', '9089998', 'Cristo Rei', '5000', '2'), ('Tiago', 'Geanezine', '90800983', '80840390943', 'Pinhais', '10000', '3'), ('Cynthia', 'Roberti', '980489', '99809300', 'Mato Grosso Sul', '7000', '4');
COMMIT;

-- ----------------------------
-- Table structure for `conta`
-- ----------------------------
DROP TABLE IF EXISTS `conta`;
CREATE TABLE `conta` (
`numConta`  int(10) NOT NULL AUTO_INCREMENT ,
`saldo`  double(10,0) NOT NULL ,
`idCliente`  int(10) NOT NULL ,
PRIMARY KEY (`numConta`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=11

;

-- ----------------------------
-- Records of conta
-- ----------------------------
BEGIN;
INSERT INTO `conta` VALUES ('10', '100', '3'), ('9', '100', '4');
COMMIT;

-- ----------------------------
-- Table structure for `contacorrente`
-- ----------------------------
DROP TABLE IF EXISTS `contacorrente`;
CREATE TABLE `contacorrente` (
`numContaCor`  int(10) NOT NULL AUTO_INCREMENT ,
`depositoInicial`  double NOT NULL ,
`limite`  double NOT NULL ,
`fkconta`  int(10) NOT NULL ,
PRIMARY KEY (`numContaCor`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of contacorrente
-- ----------------------------
BEGIN;
INSERT INTO `contacorrente` VALUES ('1', '100', '10', '10');
COMMIT;

-- ----------------------------
-- Table structure for `containvestimento`
-- ----------------------------
DROP TABLE IF EXISTS `containvestimento`;
CREATE TABLE `containvestimento` (
`numContaInvest`  int(10) NOT NULL AUTO_INCREMENT ,
`montanteMin`  double NOT NULL ,
`depositoMin`  double NOT NULL ,
`depositoInicial`  double NOT NULL ,
`fkconta`  int(10) NOT NULL ,
PRIMARY KEY (`numContaInvest`)
)
ENGINE=MyISAM
DEFAULT CHARACTER SET=latin1 COLLATE=latin1_swedish_ci
AUTO_INCREMENT=2

;

-- ----------------------------
-- Records of containvestimento
-- ----------------------------
BEGIN;
INSERT INTO `containvestimento` VALUES ('0', '0', '0', '0', '0');
COMMIT;

-- ----------------------------
-- Auto increment value for `cliente`
-- ----------------------------
ALTER TABLE `cliente` AUTO_INCREMENT=5;

-- ----------------------------
-- Indexes structure for table conta
-- ----------------------------
CREATE INDEX `idCliente` USING BTREE ON `conta`(`idCliente`);

-- ----------------------------
-- Auto increment value for `conta`
-- ----------------------------
ALTER TABLE `conta` AUTO_INCREMENT=11;

-- ----------------------------
-- Indexes structure for table contacorrente
-- ----------------------------
CREATE INDEX `fkconta` USING BTREE ON `contacorrente`(`fkconta`);

-- ----------------------------
-- Auto increment value for `contacorrente`
-- ----------------------------
ALTER TABLE `contacorrente` AUTO_INCREMENT=2;

-- ----------------------------
-- Indexes structure for table containvestimento
-- ----------------------------
CREATE INDEX `fkconta` USING BTREE ON `containvestimento`(`fkconta`);

-- ----------------------------
-- Auto increment value for `containvestimento`
-- ----------------------------
ALTER TABLE `containvestimento` AUTO_INCREMENT=2;
